create or replace view vac_app_breadcrumbs_4_1 as
with bc as
(
  select
  workspace,
  workspace_display_name,
  application_id,
  application_name,
  breadcrumb_name,
  to_char(breadcrumb_entries) breadcrumb_entries,
  last_updated_by,
  last_updated_on,
  component_comment,
  breadcrumb_id,
  component_signature
  from APEX_APPLICATION_BREADCRUMBS
)
select
  workspace,
  workspace_display_name,
  application_id,
  application_name,
  breadcrumb_name,
  last_updated_by,
  last_updated_on,
  breadcrumb_id,
  u_name,
  u_value,
  'APEX_APPLICATION_BREADCRUMBS' src_view_name
from bc
 UNPIVOT INCLUDE NULLS ( u_value
   FOR    u_name
   IN
   (
    breadcrumb_entries,
    component_comment
   )
 );

